package com.busi.wms.model;

import java.util.Map;

import com.jfinal.plugin.activerecord.Model;
import com.zcurd.common.tool.DbMetaTool;

public class WmsMaterial extends Model<WmsMaterial> {
	private static final long serialVersionUID = 1L;
	public static final WmsMaterial me = new WmsMaterial();
		
	public Map<String, Object> getDictDataunit_name() {
		return DbMetaTool.getDictData("select unit_cn 'key', unit_cn 'text' from [cquni-wms].dbo.wms_unit");
	}	
		
	public Map<String, Object> getDictDatacate_name() {
		return DbMetaTool.getDictData("select cate_name 'key',cate_name 'text' from [cquni-wms].dbo.wms_matcate");
	}	
		
	public Map<String, Object> getDictDataIs_delete() {
		return DbMetaTool.getDictData("select '0' 'key', '删除' 'text' union all select '1', '正常'");
	}	
	public Map<String, Object> getDictDataOfstorage() {
		
		return DbMetaTool.getDictData("select storage_name 'key',storage_name 'text' from [cquni-wms].dbo.wms_storage");
	}

	
}
